Pandas Profiling Report

Dataset statistics

Number of variables	28
Number of observations	2524
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	552.2 KiB
Average record size in memory	224.1 B

Variable types

Numeric	14
Categorical	5
Unsupported	9

Alerts

`nombre` has a high cardinality: 2524 distinct values	High cardinality
`cedula` is highly correlated with `saldo_total` and 1 other fields	High correlation
`no_hijos` is highly correlated with `activos` and 2 other fields	High correlation
`activos` is highly correlated with `no_hijos` and 3 other fields	High correlation
`pasivos` is highly correlated with `no_hijos` and 2 other fields	High correlation
`patrimonio` is highly correlated with `activos`	High correlation
`gastos` is highly correlated with `no_hijos` and 2 other fields	High correlation
`saldo_total` is highly correlated with `cedula` and 1 other fields	High correlation
`mora` is highly correlated with `cedula` and 1 other fields	High correlation
`activos` is highly correlated with `patrimonio`	High correlation
`patrimonio` is highly correlated with `activos`	High correlation
`dias_mora` is highly correlated with `mora`	High correlation
`mora` is highly correlated with `dias_mora`	High correlation
`cedula` is highly correlated with `mora`	High correlation
`activos` is highly correlated with `pasivos` and 2 other fields	High correlation
`pasivos` is highly correlated with `activos` and 1 other fields	High correlation
`patrimonio` is highly correlated with `activos`	High correlation
`gastos` is highly correlated with `activos` and 1 other fields	High correlation
`mora` is highly correlated with `cedula`	High correlation
`antiguedad` is highly correlated with `edad`	High correlation
`edad` is highly correlated with `antiguedad`	High correlation
`activos` is highly correlated with `patrimonio`	High correlation
`patrimonio` is highly correlated with `activos`	High correlation
`salario` is highly correlated with `saldo_total`	High correlation
`calificacion` is highly correlated with `dias_mora`	High correlation
`dias_mora` is highly correlated with `calificacion` and 1 other fields	High correlation
`saldo_total` is highly correlated with `salario`	High correlation
`mora` is highly correlated with `dias_mora`	High correlation
`activos` is highly skewed (γ1 = 38.47219861)	Skewed
`patrimonio` is highly skewed (γ1 = 38.47257644)	Skewed
`gastos` is highly skewed (γ1 = 31.83263709)	Skewed
`mora` is highly skewed (γ1 = 23.1708264)	Skewed
`cedula` is uniformly distributed	Uniform
`nombre` is uniformly distributed	Uniform
`cedula` has unique values	Unique
`nombre` has unique values	Unique
`tipo_vivienda` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ocupacion` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`nivel_academico` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`personas_a_cargo` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`tiene_casa` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`tiene_carro` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`estado_civil` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`tipo_contrato` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`entidad` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`antiguedad` has 138 (5.5%) zeros	Zeros
`no_hijos` has 1214 (48.1%) zeros	Zeros
`activos` has 1005 (39.8%) zeros	Zeros
`pasivos` has 1037 (41.1%) zeros	Zeros
`patrimonio` has 1153 (45.7%) zeros	Zeros
`gastos` has 882 (34.9%) zeros	Zeros
`dias_mora` has 2266 (89.8%) zeros	Zeros
`saldo_total` has 206 (8.2%) zeros	Zeros
`mora` has 157 (6.2%) zeros	Zeros

Reproduction

Analysis started	2022-02-19 22:06:09.725688
Analysis finished	2022-02-19 22:06:45.854548
Duration	36.13 seconds
Software version	pandas-profiling v3.1.1
Download configuration	config.json

cedula
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	2524
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1271500

Minimum	10000
Maximum	2533000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.8 KiB

Quantile statistics

Minimum	10000
5-th percentile	136150
Q1	640750
median	1271500
Q3	1902250
95-th percentile	2406850
Maximum	2533000
Range	2523000
Interquartile range (IQR)	1261500

Descriptive statistics

Standard deviation	728760.363
Coefficient of variation (CV)	0.5731501085
Kurtosis	-1.2
Mean	1271500
Median Absolute Deviation (MAD)	631000
Skewness	1.34333 × 10^-16
Sum	3209266000
Variance	5.310916667 × 10¹¹
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	1	< 0.1%
1696000	1	< 0.1%
1689000	1	< 0.1%
1690000	1	< 0.1%
1691000	1	< 0.1%
1692000	1	< 0.1%
1693000	1	< 0.1%
1694000	1	< 0.1%
1695000	1	< 0.1%
1697000	1	< 0.1%
Other values (2514)	2514	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10000	1	< 0.1%
11000	1	< 0.1%
12000	1	< 0.1%
13000	1	< 0.1%
14000	1	< 0.1%
15000	1	< 0.1%
16000	1	< 0.1%
17000	1	< 0.1%
18000	1	< 0.1%
19000	1	< 0.1%

Value	Count	Frequency (%)
2533000	1	< 0.1%
2532000	1	< 0.1%
2531000	1	< 0.1%
2530000	1	< 0.1%
2529000	1	< 0.1%
2528000	1	< 0.1%
2527000	1	< 0.1%
2526000	1	< 0.1%
2525000	1	< 0.1%
2524000	1	< 0.1%

nombre
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	2524
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	19.8 KiB

JORGE ELIECER ALDANA AMADOR	1
YASMINE ESTERLING RODRIGUEZ	1
ROSALBA BARRERA GUTIERREZ	1
FRANCIA ELENA SALAZAR SALAZAR	1
MARTHA YASMIN HERNANDEZ MORENO	1
Other values (2519)	2519

Length

Max length	39
Median length	26
Mean length	25.85697306
Min length	10

Characters and Unicode

Total characters	65263
Distinct characters	31
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2524 ?
Unique (%)	100.0%

Sample

1st row	JORGE ELIECER ALDANA AMADOR
2nd row	ELKIN ARLEY CASTRO VELANDIA
3rd row	HERSSON FERNANDO FLOREZ MORENO
4th row	BRAYAN ALEXANDER BARON ORTEGON
5th row	CINDY MAYELA OCHOA HERNANDEZ

Common Values

Value	Count	Frequency (%)
JORGE ELIECER ALDANA AMADOR	1	< 0.1%
YASMINE ESTERLING RODRIGUEZ	1	< 0.1%
ROSALBA BARRERA GUTIERREZ	1	< 0.1%
FRANCIA ELENA SALAZAR SALAZAR	1	< 0.1%
MARTHA YASMIN HERNANDEZ MORENO	1	< 0.1%
LUZ AMPARO CORDOBA PALACIOS	1	< 0.1%
RAYNER EDUARDO LOZADA LOZANO	1	< 0.1%
RAQUEL AMADO MARTINEZ	1	< 0.1%
HECTOR MIGUEL TORRES GUETTE	1	< 0.1%
MARIA EUGENIA REATIGA BARAJAS	1	< 0.1%
Other values (2514)	2514	99.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
maria	146	1.6%
rodriguez	125	1.3%
luz	94	1.0%
hernandez	82	0.9%
martinez	80	0.9%
jose	79	0.8%
moreno	73	0.8%
gonzalez	66	0.7%
garcia	66	0.7%
luis	65	0.7%
Other values (2129)	8508	90.7%

Most occurring characters

Value	Count	Frequency (%)
A	9315	14.3%
	6865	10.5%
R	5924	9.1%
E	5835	8.9%
O	4671	7.2%
I	4368	6.7%
N	3909	6.0%
L	3623	5.6%
S	2468	3.8%
D	2260	3.5%
Other values (21)	16025	24.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	58196	89.2%
Space Separator	6865	10.5%
Initial Punctuation	200	0.3%
Other Punctuation	1	< 0.1%
Control	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	9315	16.0%
R	5924	10.2%
E	5835	10.0%
O	4671	8.0%
I	4368	7.5%
N	3909	6.7%
L	3623	6.2%
S	2468	4.2%
D	2260	3.9%
M	1920	3.3%
Other values (17)	13903	23.9%

Space Separator

Value	Count	Frequency (%)
	6865	100.0%

Initial Punctuation

Value	Count	Frequency (%)
‘	200	100.0%

Other Punctuation

Value	Count	Frequency (%)
‰	1	100.0%

Control

Value	Count	Frequency (%)
	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	58196	89.2%
Common	7067	10.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	9315	16.0%
R	5924	10.2%
E	5835	10.0%
O	4671	8.0%
I	4368	7.5%
N	3909	6.7%
L	3623	6.2%
S	2468	4.2%
D	2260	3.9%
M	1920	3.3%
Other values (17)	13903	23.9%

Common

Value	Count	Frequency (%)
	6865	97.1%
‘	200	2.8%
‰	1	< 0.1%
	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	64859	99.4%
None	203	0.3%
Punctuation	201	0.3%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	9315	14.4%
	6865	10.6%
R	5924	9.1%
E	5835	9.0%
O	4671	7.2%
I	4368	6.7%
N	3909	6.0%
L	3623	5.6%
S	2468	3.8%
D	2260	3.5%
Other values (17)	15621	24.1%

None

Value	Count	Frequency (%)
Ã	202	99.5%
	1	0.5%

Punctuation

Value	Count	Frequency (%)
‘	200	99.5%
‰	1	0.5%

antiguedad
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	36
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.457210777

Minimum	0
Maximum	36
Zeros	138
Zeros (%)	5.5%
Negative	0
Negative (%)	0.0%
Memory size	19.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	10
95-th percentile	24
Maximum	36
Range	36
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	7.348317631
Coefficient of variation (CV)	0.9853976039
Kurtosis	2.208946704
Mean	7.457210777
Median Absolute Deviation (MAD)	3
Skewness	1.581106633
Sum	18822
Variance	53.997772
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
2	325	12.9%
3	245	9.7%
1	240	9.5%
5	231	9.2%
4	211	8.4%
6	182	7.2%
0	138	5.5%
7	124	4.9%
8	87	3.4%
11	68	2.7%
Other values (26)	673	26.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	138	5.5%
1	240	9.5%
2	325	12.9%
3	245	9.7%
4	211	8.4%
5	231	9.2%
6	182	7.2%
7	124	4.9%
8	87	3.4%
9	52	2.1%

Value	Count	Frequency (%)
36	16	0.6%
35	5	0.2%
34	5	0.2%
32	4	0.2%
31	3	0.1%
30	9	0.4%
29	5	0.2%
28	12	0.5%
27	18	0.7%
26	19	0.8%

activo
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	19.8 KiB

Activo	2523
Pendiente de validaciÃ³n	1

Length

Max length	24
Median length	6
Mean length	6.007131537
Min length	6

Characters and Unicode

Total characters	15162
Distinct characters	15
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Activo
2nd row	Activo
3rd row	Activo
4th row	Activo
5th row	Activo

Common Values

Value	Count	Frequency (%)
Activo	2523	> 99.9%
Pendiente de validaciÃ³n	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
activo	2523	99.9%
pendiente	1	< 0.1%
de	1	< 0.1%
validaciã³n	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
i	2526	16.7%
c	2524	16.6%
t	2524	16.6%
v	2524	16.6%
A	2523	16.6%
o	2523	16.6%
e	4	< 0.1%
n	3	< 0.1%
d	3	< 0.1%
	2	< 0.1%
Other values (5)	6	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	12634	83.3%
Uppercase Letter	2525	16.7%
Space Separator	2	< 0.1%
Other Number	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	2526	20.0%
c	2524	20.0%
t	2524	20.0%
v	2524	20.0%
o	2523	20.0%
e	4	< 0.1%
n	3	< 0.1%
d	3	< 0.1%
a	2	< 0.1%
l	1	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
A	2523	99.9%
P	1	< 0.1%
Ã	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	2	100.0%

Other Number

Value	Count	Frequency (%)
³	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	15159	> 99.9%
Common	3	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	2526	16.7%
c	2524	16.7%
t	2524	16.7%
v	2524	16.7%
A	2523	16.6%
o	2523	16.6%
e	4	< 0.1%
n	3	< 0.1%
d	3	< 0.1%
a	2	< 0.1%
Other values (3)	3	< 0.1%

Common

Value	Count	Frequency (%)
	2	66.7%
³	1	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15160	> 99.9%
None	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	2526	16.7%
c	2524	16.6%
t	2524	16.6%
v	2524	16.6%
A	2523	16.6%
o	2523	16.6%
e	4	< 0.1%
n	3	< 0.1%
d	3	< 0.1%
	2	< 0.1%
Other values (3)	4	< 0.1%

None

Value	Count	Frequency (%)
Ã	1	50.0%
³	1	50.0%

ciudad
Categorical

Distinct	5
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	19.8 KiB

GRAN	1058
VILLA	846
ACA	507
SM	112
GRA	1

Length

Max length	5
Median length	4
Mean length	4.045166403
Min length	2

Characters and Unicode

Total characters	10210
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	GRA
2nd row	GRAN
3rd row	GRAN
4th row	ACA
5th row	GRAN

Common Values

Value	Count	Frequency (%)
GRAN	1058	41.9%
VILLA	846	33.5%
ACA	507	20.1%
SM	112	4.4%
GRA	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
gran	1058	41.9%
villa	846	33.5%
aca	507	20.1%
sm	112	4.4%
gra	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	2919	28.6%
L	1692	16.6%
G	1059	10.4%
R	1059	10.4%
N	1058	10.4%
V	846	8.3%
I	846	8.3%
C	507	5.0%
S	112	1.1%
M	112	1.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	10210	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	2919	28.6%
L	1692	16.6%
G	1059	10.4%
R	1059	10.4%
N	1058	10.4%
V	846	8.3%
I	846	8.3%
C	507	5.0%
S	112	1.1%
M	112	1.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10210	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	2919	28.6%
L	1692	16.6%
G	1059	10.4%
R	1059	10.4%
N	1058	10.4%
V	846	8.3%
I	846	8.3%
C	507	5.0%
S	112	1.1%
M	112	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10210	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	2919	28.6%
L	1692	16.6%
G	1059	10.4%
R	1059	10.4%
N	1058	10.4%
V	846	8.3%
I	846	8.3%
C	507	5.0%
S	112	1.1%
M	112	1.1%

edad
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	60
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	46.43779715

Minimum	19
Maximum	80
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.8 KiB

Quantile statistics

Minimum	19
5-th percentile	28
Q1	37
median	46
Q3	55
95-th percentile	65
Maximum	80
Range	61
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	11.71739553
Coefficient of variation (CV)	0.2523245341
Kurtosis	-0.7365723054
Mean	46.43779715
Median Absolute Deviation (MAD)	9
Skewness	0.07877517473
Sum	117209
Variance	137.297358
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
39	82	3.2%
37	81	3.2%
43	80	3.2%
49	76	3.0%
44	73	2.9%
48	72	2.9%
41	71	2.8%
50	71	2.8%
45	70	2.8%
40	70	2.8%
Other values (50)	1778	70.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19	1	< 0.1%
20	3	0.1%
21	6	0.2%
22	7	0.3%
23	16	0.6%
24	17	0.7%
25	20	0.8%
26	14	0.6%
27	26	1.0%
28	35	1.4%

Value	Count	Frequency (%)
80	1	< 0.1%
79	2	0.1%
76	3	0.1%
75	4	0.2%
74	3	0.1%
73	5	0.2%
72	5	0.2%
71	8	0.3%
70	8	0.3%
69	15	0.6%

genero
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	19.8 KiB

Femenino	1622
Masculino	902

Length

Max length	9
Median length	8
Mean length	8.357369255
Min length	8

Characters and Unicode

Total characters	21094
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Masculino
2nd row	Masculino
3rd row	Masculino
4th row	Masculino
5th row	Femenino

Common Values

Value	Count	Frequency (%)
Femenino	1622	64.3%
Masculino	902	35.7%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
femenino	1622	64.3%
masculino	902	35.7%

Most occurring characters

Value	Count	Frequency (%)
n	4146	19.7%
e	3244	15.4%
i	2524	12.0%
o	2524	12.0%
F	1622	7.7%
m	1622	7.7%
M	902	4.3%
a	902	4.3%
s	902	4.3%
c	902	4.3%
Other values (2)	1804	8.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	18570	88.0%
Uppercase Letter	2524	12.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	4146	22.3%
e	3244	17.5%
i	2524	13.6%
o	2524	13.6%
m	1622	8.7%
a	902	4.9%
s	902	4.9%
c	902	4.9%
u	902	4.9%
l	902	4.9%

Uppercase Letter

Value	Count	Frequency (%)
F	1622	64.3%
M	902	35.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	21094	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	4146	19.7%
e	3244	15.4%
i	2524	12.0%
o	2524	12.0%
F	1622	7.7%
m	1622	7.7%
M	902	4.3%
a	902	4.3%
s	902	4.3%
c	902	4.3%
Other values (2)	1804	8.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21094	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	4146	19.7%
e	3244	15.4%
i	2524	12.0%
o	2524	12.0%
F	1622	7.7%
m	1622	7.7%
M	902	4.3%
a	902	4.3%
s	902	4.3%
c	902	4.3%
Other values (2)	1804	8.6%

tipo_vivienda
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	19.8 KiB

estrato
Real number (ℝ_≥0)

Distinct	7
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.188193344

Minimum	0
Maximum	6
Zeros	3
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	19.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	3
95-th percentile	3
Maximum	6
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.8207592363
Coefficient of variation (CV)	0.3750853363
Kurtosis	0.3996171532
Mean	2.188193344
Median Absolute Deviation (MAD)	1
Skewness	0.397895582
Sum	5523
Variance	0.673645724
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	1180	46.8%
3	736	29.2%
1	495	19.6%
4	93	3.7%
5	14	0.6%
0	3	0.1%
6	3	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3	0.1%
1	495	19.6%
2	1180	46.8%
3	736	29.2%
4	93	3.7%
5	14	0.6%
6	3	0.1%

Value	Count	Frequency (%)
6	3	0.1%
5	14	0.6%
4	93	3.7%
3	736	29.2%
2	1180	46.8%
1	495	19.6%
0	3	0.1%

ocupacion
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	19.8 KiB

nivel_academico
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	19.8 KiB

no_hijos
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	8
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.080031696

Minimum	0
Maximum	11
Zeros	1214
Zeros (%)	48.1%
Negative	0
Negative (%)	0.0%
Memory size	19.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	3
Maximum	11
Range	11
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.266951425
Coefficient of variation (CV)	1.173068744
Kurtosis	1.512745582
Mean	1.080031696
Median Absolute Deviation (MAD)	1
Skewness	1.090012756
Sum	2726
Variance	1.605165913
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	1214	48.1%
2	556	22.0%
1	398	15.8%
3	247	9.8%
4	82	3.2%
5	20	0.8%
6	6	0.2%
11	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1214	48.1%
1	398	15.8%
2	556	22.0%
3	247	9.8%
4	82	3.2%
5	20	0.8%
6	6	0.2%
11	1	< 0.1%

Value	Count	Frequency (%)
11	1	< 0.1%
6	6	0.2%
5	20	0.8%
4	82	3.2%
3	247	9.8%
2	556	22.0%
1	398	15.8%
0	1214	48.1%

personas_a_cargo
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	19.8 KiB

tiene_casa
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	19.8 KiB

tiene_carro
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	19.8 KiB

estado_civil
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	19.8 KiB

tipo_contrato
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	19.8 KiB

activos
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	262
Distinct (%)	10.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	219982523.1

Minimum	0
Maximum	2.50007 × 10¹¹
Zeros	1005
Zeros (%)	39.8%
Negative	0
Negative (%)	0.0%
Memory size	19.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	5000000
Q3	88250000
95-th percentile	250000000
Maximum	2.50007 × 10¹¹
Range	2.50007 × 10¹¹
Interquartile range (IQR)	88250000

Descriptive statistics

Standard deviation	5802217285
Coefficient of variation (CV)	26.37581024
Kurtosis	1538.062468
Mean	219982523.1
Median Absolute Deviation (MAD)	5000000
Skewness	38.47219861
Sum	5.552358882 × 10¹¹
Variance	3.366572542 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1005	39.8%
1	126	5.0%
150000000	92	3.6%
50000000	66	2.6%
100000000	65	2.6%
200000000	63	2.5%
5000000	52	2.1%
80000000	41	1.6%
30000000	41	1.6%
60000000	40	1.6%
Other values (252)	933	37.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1005	39.8%
1	126	5.0%
2	3	0.1%
4	2	0.1%
35	1	< 0.1%
100000	3	0.1%
150000	1	< 0.1%
200000	2	0.1%
240000	1	< 0.1%
300000	3	0.1%

Value	Count	Frequency (%)
2.50007 × 10¹¹	1	< 0.1%
1.5 × 10¹¹	1	< 0.1%
4050000000	1	< 0.1%
2010000000	1	< 0.1%
1200000000	1	< 0.1%
955000000	1	< 0.1%
850000000	2	0.1%
844300000	1	< 0.1%
800000000	1	< 0.1%
740000000	1	< 0.1%

pasivos
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	288
Distinct (%)	11.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27934840.26

Minimum	0
Maximum	2500000000
Zeros	1037
Zeros (%)	41.1%
Negative	0
Negative (%)	0.0%
Memory size	19.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	965000
Q3	40000000
95-th percentile	120000000
Maximum	2500000000
Range	2500000000
Interquartile range (IQR)	40000000

Descriptive statistics

Standard deviation	69282001.47
Coefficient of variation (CV)	2.480128786
Kurtosis	648.0347743
Mean	27934840.26
Median Absolute Deviation (MAD)	965000
Skewness	19.27261303
Sum	7.050753682 × 10¹⁰
Variance	4.799995728 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1037	41.1%
1	126	5.0%
50000000	62	2.5%
30000000	56	2.2%
100000000	50	2.0%
40000000	48	1.9%
20000000	47	1.9%
60000000	46	1.8%
80000000	44	1.7%
10000000	35	1.4%
Other values (278)	973	38.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1037	41.1%
1	126	5.0%
2	5	0.2%
24500	1	< 0.1%
30000	1	< 0.1%
50000	1	< 0.1%
100000	9	0.4%
150000	2	0.1%
180000	1	< 0.1%
200000	6	0.2%

Value	Count	Frequency (%)
2500000000	1	< 0.1%
700000000	1	< 0.1%
500000000	1	< 0.1%
450000000	2	0.1%
360000000	1	< 0.1%
331200000	1	< 0.1%
300000000	1	< 0.1%
265000000	1	< 0.1%
250000000	5	0.2%
240000000	1	< 0.1%

patrimonio
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	603
Distinct (%)	23.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	190867161.4

Minimum	-2325000000
Maximum	2.49952 × 10¹¹
Zeros	1153
Zeros (%)	45.7%
Negative	355
Negative (%)	14.1%
Memory size	19.8 KiB

Quantile statistics

Minimum	-2325000000
5-th percentile	-38000000
Q1	0
median	0
Q3	33700000
95-th percentile	191700000
Maximum	2.49952 × 10¹¹
Range	2.52277 × 10¹¹
Interquartile range (IQR)	33700000

Descriptive statistics

Standard deviation	5801898577
Coefficient of variation (CV)	30.39757355
Kurtosis	1537.970322
Mean	190867161.4
Median Absolute Deviation (MAD)	3000000
Skewness	38.47257644
Sum	4.817487154 × 10¹¹
Variance	3.36620271 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1153	45.7%
20000000	36	1.4%
70000000	33	1.3%
10000000	30	1.2%
50000000	27	1.1%
30000000	27	1.1%
100000000	19	0.8%
150000000	15	0.6%
1000000	15	0.6%
5000000	15	0.6%
Other values (593)	1154	45.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-2325000000	1	< 0.1%
-655000000	1	< 0.1%
-220000000	1	< 0.1%
-150000000	1	< 0.1%
-148600000	1	< 0.1%
-140000000	1	< 0.1%
-130000000	1	< 0.1%
-127000000	1	< 0.1%
-120000000	1	< 0.1%
-115500000	1	< 0.1%

Value	Count	Frequency (%)
2.49952 × 10¹¹	1	< 0.1%
1.499995 × 10¹¹	1	< 0.1%
4047000000	1	< 0.1%
1510000000	1	< 0.1%
1175000000	1	< 0.1%
800000000	1	< 0.1%
730000000	1	< 0.1%
725000000	1	< 0.1%
641000000	1	< 0.1%
600000000	1	< 0.1%

salario
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1329
Distinct (%)	52.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3181291.113

Minimum	1
Maximum	50919989
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1167812
Q1	1896063
median	2633097
Q3	3919989
95-th percentile	6940665.25
Maximum	50919989
Range	50919988
Interquartile range (IQR)	2023926

Descriptive statistics

Standard deviation	2270543.211
Coefficient of variation (CV)	0.7137175223
Kurtosis	101.6720346
Mean	3181291.113
Median Absolute Deviation (MAD)	900835.5
Skewness	6.629771286
Sum	8029578769
Variance	5.155366472 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2209679	87	3.4%
1896063	48	1.9%
2290026	41	1.6%
4398643	40	1.6%
1621543	31	1.2%
3641927	29	1.1%
1755704	29	1.1%
2040828	28	1.1%
4244314	26	1.0%
4000000	25	1.0%
Other values (1319)	2140	84.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	0.1%
616000	1	< 0.1%
689454	1	< 0.1%
689455	1	< 0.1%
708230	1	< 0.1%
731852	1	< 0.1%
737717	1	< 0.1%
740000	1	< 0.1%
781242	4	0.2%
791769	1	< 0.1%

Value	Count	Frequency (%)
50919989	1	< 0.1%
35555000	1	< 0.1%
25000000	1	< 0.1%
21567708	1	< 0.1%
19200000	1	< 0.1%
19000000	1	< 0.1%
16745211	1	< 0.1%
15224282	1	< 0.1%
12919989	1	< 0.1%
12800000	1	< 0.1%

gastos
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	280
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1392213.583

Minimum	0
Maximum	301500000
Zeros	882
Zeros (%)	34.9%
Negative	0
Negative (%)	0.0%
Memory size	19.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	755000
Q3	1585000
95-th percentile	3643450
Maximum	301500000
Range	301500000
Interquartile range (IQR)	1585000

Descriptive statistics

Standard deviation	7233586.331
Coefficient of variation (CV)	5.195744691
Kurtosis	1222.356657
Mean	1392213.583
Median Absolute Deviation (MAD)	755000
Skewness	31.83263709
Sum	3513947083
Variance	5.232477121 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	882	34.9%
1000000	188	7.4%
2000000	123	4.9%
1500000	104	4.1%
800000	101	4.0%
500000	93	3.7%
600000	87	3.4%
1200000	74	2.9%
700000	66	2.6%
3000000	57	2.3%
Other values (270)	749	29.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	882	34.9%
1	5	0.2%
4	1	< 0.1%
100000	11	0.4%
140000	1	< 0.1%
200000	9	0.4%
220000	1	< 0.1%
250000	2	0.1%
300000	33	1.3%
327500	1	< 0.1%

Value	Count	Frequency (%)
301500000	1	< 0.1%
119000000	1	< 0.1%
102500000	1	< 0.1%
62926000	1	< 0.1%
61000000	1	< 0.1%
51500000	1	< 0.1%
40000002	1	< 0.1%
30000000	1	< 0.1%
27990000	1	< 0.1%
16600000	1	< 0.1%

entidad
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	19.8 KiB

no_productos
Real number (ℝ_≥0)

Distinct	7
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.54318542

Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	9
Range	8
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7752341748
Coefficient of variation (CV)	0.5023597066
Kurtosis	5.769445993
Mean	1.54318542
Median Absolute Deviation (MAD)	0
Skewness	1.804606453
Sum	3895
Variance	0.6009880259
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	1492	59.1%
2	768	30.4%
3	208	8.2%
4	43	1.7%
5	10	0.4%
6	2	0.1%
9	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1492	59.1%
2	768	30.4%
3	208	8.2%
4	43	1.7%
5	10	0.4%
6	2	0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
9	1	< 0.1%
6	2	0.1%
5	10	0.4%
4	43	1.7%
3	208	8.2%
2	768	30.4%
1	1492	59.1%

calificacion
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	19.8 KiB

A	2391
E	78
B	32
D	15
C	8

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	2524
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A
2nd row	A
3rd row	A
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	2391	94.7%
E	78	3.1%
B	32	1.3%
D	15	0.6%
C	8	0.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
a	2391	94.7%
e	78	3.1%
b	32	1.3%
d	15	0.6%
c	8	0.3%

Most occurring characters

Value	Count	Frequency (%)
A	2391	94.7%
E	78	3.1%
B	32	1.3%
D	15	0.6%
C	8	0.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2524	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	2391	94.7%
E	78	3.1%
B	32	1.3%
D	15	0.6%
C	8	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2524	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	2391	94.7%
E	78	3.1%
B	32	1.3%
D	15	0.6%
C	8	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2524	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	2391	94.7%
E	78	3.1%
B	32	1.3%
D	15	0.6%
C	8	0.3%

dias_mora
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	63
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.99207607

Minimum	0
Maximum	3630
Zeros	2266
Zeros (%)	89.8%
Negative	0
Negative (%)	0.0%
Memory size	19.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	55
Maximum	3630
Range	3630
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	181.3668933
Coefficient of variation (CV)	6.255740117
Kurtosis	118.6926099
Mean	28.99207607
Median Absolute Deviation (MAD)	0
Skewness	9.634143471
Sum	73176
Variance	32893.95
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2266	89.8%
25	107	4.2%
55	26	1.0%
30	20	0.8%
85	6	0.2%
175	5	0.2%
235	4	0.2%
450	4	0.2%
295	4	0.2%
570	3	0.1%
Other values (53)	79	3.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2266	89.8%
25	107	4.2%
30	20	0.8%
55	26	1.0%
60	3	0.1%
85	6	0.2%
90	3	0.1%
115	3	0.1%
145	3	0.1%
150	1	< 0.1%

Value	Count	Frequency (%)
3630	1	< 0.1%
2459	1	< 0.1%
2152	1	< 0.1%
1980	1	< 0.1%
1830	1	< 0.1%
1795	1	< 0.1%
1740	1	< 0.1%
1735	1	< 0.1%
1680	1	< 0.1%
1675	1	< 0.1%

saldo_total
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	2271
Distinct (%)	90.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10443854.11

Minimum	0
Maximum	257318078
Zeros	206
Zeros (%)	8.2%
Negative	0
Negative (%)	0.0%
Memory size	19.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	605599.5
median	2106686.5
Q3	10442965.75
95-th percentile	49406588.3
Maximum	257318078
Range	257318078
Interquartile range (IQR)	9837366.25

Descriptive statistics

Standard deviation	19720873.12
Coefficient of variation (CV)	1.88827543
Kurtosis	20.95712341
Mean	10443854.11
Median Absolute Deviation (MAD)	1937246
Skewness	3.691864227
Sum	2.636028778 × 10¹⁰
Variance	3.889128366 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	206	8.2%
750450	27	1.1%
500300	5	0.2%
400240	4	0.2%
550330	3	0.1%
350210	2	0.1%
6809756	2	0.1%
600360	2	0.1%
404752	2	0.1%
300180	2	0.1%
Other values (2261)	2269	89.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	206	8.2%
2	1	< 0.1%
561	1	< 0.1%
1149	1	< 0.1%
1485	1	< 0.1%
5951	1	< 0.1%
23365	1	< 0.1%
26146	1	< 0.1%
46961	1	< 0.1%
47094	1	< 0.1%

Value	Count	Frequency (%)
257318078	1	< 0.1%
178985144	1	< 0.1%
158988393	1	< 0.1%
154331658	1	< 0.1%
134666076	1	< 0.1%
133645264	1	< 0.1%
129749791	1	< 0.1%
129245037	1	< 0.1%
119474394	1	< 0.1%
111360398	1	< 0.1%

mora
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	2292
Distinct (%)	90.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1197997.478

Minimum	0
Maximum	163603870
Zeros	157
Zeros (%)	6.2%
Negative	0
Negative (%)	0.0%
Memory size	19.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	235551.25
median	532156
Q3	1253856.5
95-th percentile	3284678.15
Maximum	163603870
Range	163603870
Interquartile range (IQR)	1018305.25

Descriptive statistics

Standard deviation	4587891.652
Coefficient of variation (CV)	3.829633814
Kurtosis	699.2558484
Mean	1197997.478
Median Absolute Deviation (MAD)	383000.5
Skewness	23.1708264
Sum	3023745635
Variance	2.104874981 × 10¹³
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	157	6.2%
385584	27	1.1%
205645	5	0.2%
257056	5	0.2%
528658	3	0.1%
282762	3	0.1%
179939	3	0.1%
664664	3	0.1%
353604	3	0.1%
107145	2	0.1%
Other values (2282)	2313	91.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	157	6.2%
174	1	< 0.1%
2160	2	0.1%
3000	2	0.1%
6271	1	< 0.1%
9000	2	0.1%
11157	1	< 0.1%
12000	1	< 0.1%
12844	1	< 0.1%
17592	1	< 0.1%

Value	Count	Frequency (%)
163603870	1	< 0.1%
78433507	1	< 0.1%
75132454	1	< 0.1%
55830006	1	< 0.1%
52220345	1	< 0.1%
45265705	1	< 0.1%
31283561	1	< 0.1%
25426725	1	< 0.1%
25358948	1	< 0.1%
24459090	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	cedula	nombre	antiguedad	activo	ciudad	edad	genero	tipo_vivienda	estrato	ocupacion	nivel_academico	no_hijos	personas_a_cargo	tiene_casa	tiene_carro	estado_civil	tipo_contrato	activos	pasivos	patrimonio	salario	gastos	entidad	no_productos	calificacion	saldo_total
0	10000	JORGE ELIECER ALDANA AMADOR	4	Activo	GRA	54	Masculino	ARRENDADA	2	DOCENTE	Universitario	4	Cuatro o mas	0	0	Casado	A tÃ©rmino Indefinido	1	1	0	1149906	1000000	GOB MT	1	A	492687.0
1	11000	ELKIN ARLEY CASTRO VELANDIA	1	Activo	GRAN	29	Masculino	PROPIA	2	EMPLEADO PUBLICO NO DOCENTE	TÃ©cnico	0	Cero	0	0	Union Libre	A tÃ©rmino Indefinido	100000000	16000000	0	1228925	1000000	EJER NAL	1	A	395715.0
2	12000	HERSSON FERNANDO FLOREZ MORENO	6	Activo	GRAN	29	Masculino	FAMILIAR	3	DOCENTE	TÃ©cnico	1	Una	N	N	Soltero	A tÃ©rmino Fijo	1	84000000	-83999999	2319409	1540000	GOB MT	1	A	603910.0
3	13000	BRAYAN ALEXANDER BARON ORTEGON	0	Activo	ACA	31	Masculino	ARRENDADA	2	Tecnico	Universitario	0	Cero	0	0	Soltero	A tÃ©rmino Indefinido	0	0	0	1854448	900000	MPIO EL DORA	1	A	631766.0
4	14000	CINDY MAYELA OCHOA HERNANDEZ	5	Activo	GRAN	34	Femenino	PROPIA	2	DOCENTE	Especializacion	1	Una	0	0	Casado	A tÃ©rmino Indefinido	150000000	67000000	83000000	2489102	1000000	GOB MT	1	A	0.0
5	15000	LEIDY JOHANA PARRADO GALINDEZ	17	Activo	GRAN	36	Femenino	PROPIA	1	DOCENTE SECUNDARIA	Universitario	1	Una	N	N	Union Libre	A tÃ©rmino Indefinido	200000000	100000000	100000000	7576449	800000	GOB MT	1	A	38563398.0
6	16000	CAMILO ANDRES HIGUAVITA CORREA	0	Activo	VILLA	36	Masculino	ARRENDADA	3	CONTRATISTA	TecnolÃ³gico	1	Una	N	N	Soltero	A tÃ©rmino Indefinido	35000000	1000000	0	2189163	800000	MUNICIPIO DE PTO GAI	1	A	333834.0
7	17000	LEIDY ALEXANDRA NARANJO LOZANO	0	Activo	GRAN	39	Femenino	PROPIA	2	CONTADOR (A)	Universitario	2	Tres	N	N	Separaci?n Judicial	A tÃ©rmino Fijo	102000000	20000000	0	2511300	600000	SOC SALEC	1	A	556867.0
8	18000	MARIA LUZ DARY ABRIL NIÃ‘O	7	Activo	ACA	55	Femenino	ARRENDADA	2	DOCENTE	Especializacion	3	Una	0	0	Soltero	A tÃ©rmino Indefinido	10000000	60000000	-50000000	4244314	800000	GOB MT	1	A	100640.0
9	19000	ALONSO BONILLA NIÃ‘O	0	Activo	ACA	61	Masculino	PROPIA	4	TECNOLOGO	TecnolÃ³gico	0	Una	N	N	Casado	A tÃ©rmino Fijo	240000000	35000000	205000000	2576925	1000000	HOSP ACA	1	A	0.0

Last rows

	cedula	nombre	antiguedad	activo	ciudad	edad	genero	tipo_vivienda	estrato	ocupacion	nivel_academico	personas_a_cargo	estado_civil	tipo_contrato	salario	entidad	no_productos	calificacion	dias_mora	saldo_total	mora
2514	2524000	EMMA IDE ALFONSO ALFONSO	13	Activo	VILLA	42	Femenino	PROPIA	1	Otros	Universitario	Cero	Union Libre	A tÃ©rmino Indefinido	2406519	GOB MT	3	E	955	13574761.0	24459090
2515	2525000	ROSA ELENA CARDOZO HERMOSA	9	Activo	GRAN	54	Femenino	PROPIA	2	Otros	Bachillerato	Una	Soltero	A tÃ©rmino Indefinido	791769	MPIO JUAN	9	A	30	3649086.0	25358948
2516	2526000	MARLY YISETH BUITRAGO MONTEALEGRE	9	Activo	GRAN	31	Femenino	ARRENDADA	1	Otros	TecnolÃ³gico	Cero	Casado	A tÃ©rmino Fijo	850000	CONC S JUAN	3	E	1255	12703438.0	25426725
2517	2527000	FLOR DEL CARMEN MEDINA MARTIN	6	Activo	VILLA	55	Femenino	PROPIA	3	Otros	Postgrado	Una	Casado	Otra	6133182	PREVI S.A.	1	E	960	20906958.0	31283561
2518	2528000	GUILLERMO TOBON BORRERO	6	Activo	VILLA	62	Masculino	PROPIA	3	Otros	Postgrado	Cero	Casado	A tÃ©rmino Indefinido	3120336	MUN VCIO	4	E	1735	13884066.0	45265705
2519	2529000	OFELIA PEREZ	21	Activo	GRAN	63	Femenino	ARRENDADA	2	Otros	TecnolÃ³gico	Cero	Union Libre	0	1167812	0	2	E	990	12678497.0	52220345
2520	2530000	DORIS EDIT PARRADO PARRADO	7	Activo	GRAN	56	Femenino	PROPIA	3	Otros	TÃ©cnico	Cero	Soltero	0	3300000	0	1	E	1740	26341773.0	55830006
2521	2531000	LUIS HERLEY JIMENEZ VALENCIA	6	Activo	VILLA	53	Masculino	PROPIA	3	Otros	Bachillerato	Cero	Casado	A tÃ©rmino Indefinido	2402900	MUN VCIO	6	E	1345	26442992.0	75132454
2522	2532000	ANGELICA MARIA BLANCO QUINTERO	13	Activo	VILLA	43	Femenino	PROPIA	3	Otros	Postgrado	Cero	Casado	A tÃ©rmino Indefinido	5872590	MUN VCIO	3	E	865	17119909.0	78433507
2523	2533000	LUIS MIGUEL DIAZ CUBIDES	21	Activo	VILLA	61	Masculino	PROPIA	3	Otros	Postgrado	Cero	Union Libre	0	2129772	0	1	E	3630	39753981.0	163603870

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Initial Punctuation

Other Punctuation

Control

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Punctuation

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions